OpenCities Map CONNECT Edition Help

Oracle Built-in Data Type Matching

Oracle Datatype

XFM Datatype

VARCHAR2(size [BYTE | CHAR])

String

NVARCHAR2(size)

String

NUMBER[(precision [, scale]])

Double

LONG

NOT MODELED

DATE

Date

BINARY_FLOAT

NOT MODELED

BINARY_DOUBLE

NOT MODELED

TIMESTAMP [(fractional_seconds)]

NOT MODELED

TIMESTAMP [(fractional_seconds)] WITH TIME ZONE

NOT MODELED

TIMESTAMP [(fractional_seconds)] WITH LOCAL TIME ZONE

NOT MODELED

INTERVAL YEAR [(year_precision)] TO MONTH

NOT MODELED

INTERVAL DAY [(day_precision)] TO SECOND [(fractional_seconds)]

NOT MODELED

RAW(size)

NOT MODELED

LONG RAW

NOT MODELED

ROWID

NOT MODELED

UROWID [(size)]

NOT MODELED

CHAR [(size [BYTE | CHAR])]

String

NCHAR[(size)]

String

CLOB

NOT MODELED

NCLOB

NOT MODELED

BLOB

NOT MODELED

BFILE

NOT MODELED